When populating a data range to a chart by right-clicking the range in the workbook, you get the following options in the popup menu:
Choose 'Populate and use 'Advanced Chart Type' and the following form pops up: